This particular report emphasizes on the OQC results for the DVT Bikes, PQE have logged 262 DVT bikes across three different contracted manufacturers (CM) from TConn, Ideal and Speedtech.
The detailed DVT bikes which were OQCed at the CM site are as follows:
total_qty## TConn Ideal Speedtech
## 222 15 25The latter section will be split into preliminary data setup, then the display of yield rate distribution and visualized distribution for the pass/fail fraction.
For the OQC inspection items, the component type will be split into
Mechanical and Eletrical for the
classification. And the aspects will be split into
Function, Cosmetics and Safety.
Lastly, the inspection style will also be split as Static
and Dynamic.
Therefore, for individual OQC items, there will be split into the following pseudo code rule.
e.g SF01 where S means Static inspection style,
F means Function and 01 is the 1st serial
item.
This section will summarize cumulative data based on all 3 CMs, the following code will illustrate the brief % of pass, fail and did not inspect (DNI)% for both static and dynamic test for DVT bikes.
# Make it as a kable
kable(overall_static_sum) %>%
kable_styling(bootstrap_options = c("striped", "hover"))| Overall Pass % | Overall Fail % | Overall DNI % | |
|---|---|---|---|
| Front Light (SF01) | 85.11 | 1.15 | 13.74 |
| Rear Light (SF02) | 84.73 | 1.53 | 13.74 |
| LED Ring (SF03) | 82.82 | 3.44 | 13.74 |
| Frame Noise (SC01) | 94.27 | 0.76 | 4.96 |
| Handlebar Cosmetics (SC02) | 94.27 | 4.58 | 1.15 |
| Kickstand Noise (SF04) | 17.56 | 77.48 | 4.96 |
| E-Shifter Plug Cosmetics (SC02) | 94.27 | 4.58 | 1.15 |
| Charger Plug Cosmetics (SC03) | 83.21 | 3.44 | 13.36 |
| Brake Tube (SS01) | 91.60 | 3.05 | 5.34 |
| Battery Function (SF05) | 86.26 | 0.00 | 13.74 |
| Kicklock Function (SF06) | 85.11 | 1.15 | 13.74 |
| Main ECU (SF07) | 86.26 | 0.00 | 13.74 |
| Horn Function (SF08) | 86.26 | 0.00 | 13.74 |
| Frame Cosmetics (SC04) | 29.77 | 69.08 | 1.15 |
| Front Fork Cosmetics (SC05) | 67.94 | 30.92 | 1.15 |
| Front Fender Cosmetics (SC06) | 60.69 | 38.17 | 1.15 |
| Rear Fender Cosmetics (SC07) | 50.38 | 48.47 | 1.15 |
| Handlebar Grip Gap (SC08) | 57.63 | 37.79 | 4.58 |
| Assistance Level Change (SF09) | 85.88 | 0.38 | 13.74 |
ggplotly(static_1)# Make it as a kable
kable(overall_dynamic_sum) %>%
kable_styling(bootstrap_options = c("striped", "hover"))| Overall Pass % | Overall Fail % | Overall DNI % | |
|---|---|---|---|
| Brake System (DS01) | 77.48 | 16.03 | 6.49 |
| BB Sensor (DF01) | 85.50 | 0.38 | 14.12 |
| Front Brake Disc Noise (DF02) | 85.50 | 4.58 | 9.92 |
| Rear Brake Disc Noise (DF03) | 88.93 | 1.15 | 9.92 |
| Chain Guard Issue (DF04) | 73.66 | 16.79 | 9.54 |
| Wheelset Wobble (DS02) | 89.69 | 0.38 | 9.92 |
| Dynamic E-Shifter Gear Shifting (DF05) | 64.89 | 20.99 | 14.12 |
| Motor (DF06) | 79.77 | 5.73 | 14.50 |
| Kicklock Noise (DF07) | 78.24 | 7.25 | 14.50 |
| Rear Hub Noise (DF08) | 84.35 | 1.15 | 14.50 |
ggplotly(dynamic_1)This section will summarize data from TConn, the following code will illustrate the brief % of pass, fail and did not inspect (DNI)% for both static and dynamic test for DVT bikes.
# Make it as a kable
kable(tconn_static_sum) %>%
kable_styling(bootstrap_options = c("striped", "hover"))| TConn Pass % | TConn Fail % | TConn DNI % | |
|---|---|---|---|
| Front Light (SF01) | 82.43 | 1.35 | 16.22 |
| Rear Light (SF02) | 82.43 | 1.35 | 16.22 |
| LED Ring (SF03) | 80.63 | 3.15 | 16.22 |
| Frame Noise (SC01) | 94.14 | 0.00 | 5.86 |
| Handlebar Cosmetics (SC02) | 96.85 | 1.80 | 1.35 |
| Kickstand Noise (SF04) | 19.37 | 74.77 | 5.86 |
| E-Shifter Plug Cosmetics (SC02) | 96.85 | 1.80 | 1.35 |
| Charger Plug Cosmetics (SC03) | 83.33 | 1.35 | 15.32 |
| Brake Tube (SS01) | 90.09 | 3.60 | 6.31 |
| Battery Function (SF05) | 83.78 | 0.00 | 16.22 |
| Kicklock Function (SF06) | 82.43 | 1.35 | 16.22 |
| Main ECU (SF07) | 83.78 | 0.00 | 16.22 |
| Horn Function (SF08) | 83.78 | 0.00 | 16.22 |
| Frame Cosmetics (SC04) | 30.18 | 68.47 | 1.35 |
| Front Fork Cosmetics (SC05) | 73.87 | 24.77 | 1.35 |
| Front Fender Cosmetics (SC06) | 65.77 | 32.88 | 1.35 |
| Rear Fender Cosmetics (SC07) | 54.05 | 44.59 | 1.35 |
| Handlebar Grip Gap (SC08) | 65.77 | 32.88 | 1.35 |
| Assistance Level Change (SF09) | 83.33 | 0.45 | 16.22 |
ggplotly(static_2)# Make it as a kable
kable(tconn_dynamic_sum) %>%
kable_styling(bootstrap_options = c("striped", "hover"))| TConn Pass % | TConn Fail % | TConn DNI % | |
|---|---|---|---|
| Brake System (DS01) | 75.23 | 17.57 | 7.21 |
| BB Sensor (DF01) | 83.33 | 0.45 | 16.22 |
| Front Brake Disc Noise (DF02) | 83.78 | 4.95 | 11.26 |
| Rear Brake Disc Noise (DF03) | 87.39 | 1.35 | 11.26 |
| Chain Guard Issue (DF04) | 69.82 | 19.37 | 10.81 |
| Wheelset Wobble (DS02) | 88.29 | 0.45 | 11.26 |
| Dynamic E-Shifter Gear Shifting (DF05) | 68.92 | 14.86 | 16.22 |
| Motor (DF06) | 79.28 | 4.05 | 16.67 |
| Kicklock Noise (DF07) | 74.77 | 8.56 | 16.67 |
| Rear Hub Noise (DF08) | 82.43 | 0.90 | 16.67 |
ggplotly(dynamic_2)This section will summarize data from Ideal, the following code will illustrate the brief % of pass, fail and did not inspect (DNI)% for both static and dynamic test for DVT bikes.
# Make it as a kable
kable(ideal_static_sum) %>%
kable_styling(bootstrap_options = c("striped", "hover"))| Ideal Pass % | Ideal Fail % | Ideal DNI % | |
|---|---|---|---|
| Front Light (SF01) | 100.00 | 0.00 | 0.00 |
| Rear Light (SF02) | 93.33 | 6.67 | 0.00 |
| LED Ring (SF03) | 93.33 | 6.67 | 0.00 |
| Frame Noise (SC01) | 100.00 | 0.00 | 0.00 |
| Handlebar Cosmetics (SC02) | 66.67 | 33.33 | 0.00 |
| Kickstand Noise (SF04) | 13.33 | 86.67 | 0.00 |
| E-Shifter Plug Cosmetics (SC02) | 66.67 | 33.33 | 0.00 |
| Charger Plug Cosmetics (SC03) | 73.33 | 20.00 | 6.67 |
| Brake Tube (SS01) | 100.00 | 0.00 | 0.00 |
| Battery Function (SF05) | 100.00 | 0.00 | 0.00 |
| Kicklock Function (SF06) | 100.00 | 0.00 | 0.00 |
| Main ECU (SF07) | 100.00 | 0.00 | 0.00 |
| Horn Function (SF08) | 100.00 | 0.00 | 0.00 |
| Frame Cosmetics (SC04) | 66.67 | 33.33 | 0.00 |
| Front Fork Cosmetics (SC05) | 93.33 | 6.67 | 0.00 |
| Front Fender Cosmetics (SC06) | 33.33 | 66.67 | 0.00 |
| Rear Fender Cosmetics (SC07) | 26.67 | 73.33 | 0.00 |
| Handlebar Grip Gap (SC08) | 13.33 | 86.67 | 0.00 |
| Assistance Level Change (SF09) | 100.00 | 0.00 | 0.00 |
ggplotly(static_3)# Make it as a kable
kable(ideal_dynamic_sum) %>%
kable_styling(bootstrap_options = c("striped", "hover"))| Ideal Pass % | Ideal Fail % | Ideal DNI % | |
|---|---|---|---|
| Brake System (DS01) | 100 | 0 | 0 |
| BB Sensor (DF01) | 100 | 0 | 0 |
| Front Brake Disc Noise (DF02) | 100 | 0 | 0 |
| Rear Brake Disc Noise (DF03) | 100 | 0 | 0 |
| Chain Guard Issue (DF04) | 100 | 0 | 0 |
| Wheelset Wobble (DS02) | 100 | 0 | 0 |
| Dynamic E-Shifter Gear Shifting (DF05) | 60 | 40 | 0 |
| Motor (DF06) | 60 | 40 | 0 |
| Kicklock Noise (DF07) | 100 | 0 | 0 |
| Rear Hub Noise (DF08) | 100 | 0 | 0 |
ggplotly(dynamic_3)This section will summarize data from Speedtech, the following code will illustrate the brief % of pass, fail and did not inspect (DNI)% for both static and dynamic test for DVT bikes.
# Make it as a kable
kable(speedtech_static_sum) %>%
kable_styling(bootstrap_options = c("striped", "hover"))| Speedtech Pass % | Speedtech Fail % | Speedtech DNI % | |
|---|---|---|---|
| Front Light (SF01) | 100 | 0 | 0 |
| Rear Light (SF02) | 100 | 0 | 0 |
| LED Ring (SF03) | 96 | 4 | 0 |
| Frame Noise (SC01) | 92 | 8 | 0 |
| Handlebar Cosmetics (SC02) | 88 | 12 | 0 |
| Kickstand Noise (SF04) | 4 | 96 | 0 |
| E-Shifter Plug Cosmetics (SC02) | 88 | 12 | 0 |
| Charger Plug Cosmetics (SC03) | 88 | 12 | 0 |
| Brake Tube (SS01) | 100 | 0 | 0 |
| Battery Function (SF05) | 100 | 0 | 0 |
| Kicklock Function (SF06) | 100 | 0 | 0 |
| Main ECU (SF07) | 100 | 0 | 0 |
| Horn Function (SF08) | 100 | 0 | 0 |
| Frame Cosmetics (SC04) | 4 | 96 | 0 |
| Front Fork Cosmetics (SC05) | 0 | 100 | 0 |
| Front Fender Cosmetics (SC06) | 32 | 68 | 0 |
| Rear Fender Cosmetics (SC07) | 32 | 68 | 0 |
| Handlebar Grip Gap (SC08) | 12 | 52 | 36 |
| Assistance Level Change (SF09) | 100 | 0 | 0 |
ggplotly(static_4)# Make it as a kable
kable(speedtech_dynamic_sum) %>%
kable_styling(bootstrap_options = c("striped", "hover"))| Speedtech Pass % | Speedtech Fail % | Speedtech DNI % | |
|---|---|---|---|
| Brake System (DS01) | 84 | 12 | 4 |
| BB Sensor (DF01) | 96 | 0 | 4 |
| Front Brake Disc Noise (DF02) | 92 | 4 | 4 |
| Rear Brake Disc Noise (DF03) | 96 | 0 | 4 |
| Chain Guard Issue (DF04) | 92 | 4 | 4 |
| Wheelset Wobble (DS02) | 96 | 0 | 4 |
| Dynamic E-Shifter Gear Shifting (DF05) | 32 | 64 | 4 |
| Motor (DF06) | 96 | 0 | 4 |
| Kicklock Noise (DF07) | 96 | 0 | 4 |
| Rear Hub Noise (DF08) | 92 | 4 | 4 |
ggplotly(dynamic_4)Based on the observation and required criteria, the first past yield for PQE is to consider a passed bike is a bike which passes ALL the inspection items without rework done or being concessioned.
After observing all the DVT bikes, the yield rate for PQE’s observation is 0% due to all of the DVT bikes require rework process or concession. Reasons such as e-shifter stuck at gear 3 during test ride and other concession items from brake malfunction or kickstand hitting frames shall be considered for significant improvement before going to PVT or even mass production.
Due to the instability within the component of SA5 Bike, PQE does not recommend to proceed PVT unless these open findings from DVT is solved or improvised.